<?php

$query = "select num_Jugador as NUMERO,nom_Jugador as NOMBRE,goles as GOLES from Cat_Jugadores where goles > 0 order by goles desc";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
    echo "<td width=\"10%\"><center><font face=\"verdana\">" .
    $row["NUMERO"] . "</font></center></td>";
    echo "<td width=\"80%\"><font face=\"verdana\">" .
    $row["NOMBRE"] . "</font></td>";
    echo "<td width=\"10%\"><center><font face=\"verdana\">" .
    $row["GOLES"] . "</font></center></td></tr>";
 
}
mysql_free_result($result);
mysql_close($link);
?>
